package StudentProject.dao;

import StudentProject.bean.Student;
import StudentProject.bean.User;

import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public interface StudentDao {

    //添加学生信息
    boolean insert(Student student);

    //删除学生信息(按照id删除)
    boolean deleteId(int student_id);

    //删除学生信息(按照姓名)
    boolean deleteName(String name);

    //修改学生信息
    boolean update(Student student);

    //按照id查询学生信息
    Student selectId(int student_id);

    //查询姓名
    Student selectAll(String name);

    //查询所有
    Student select();

    //分类查询
    List<Student> selectStudents(int pageNumber, int pageSize);

    //排序查询
    Student select(int choice, int orderChoice);

    //成绩查询
    void queryGrade(Scanner scanner);
}
